-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: mysql5.cws.oregonstate.edu
-- Generation Time: May 22, 2019 at 12:40 PM
-- Server version: 5.1.63
-- PHP Version: 5.3.3-7+squeeze9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `cw_61046`
--

-- --------------------------------------------------------

--
-- Table structure for table `DataFields`
--

CREATE TABLE IF NOT EXISTS `DataFields` (
  `FieldTable` text NOT NULL,
  `FirstName` text NOT NULL,
  `FieldDescrip` text NOT NULL,
  `FieldUse` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DataFields`
--

INSERT INTO `DataFields` (`FieldTable`, `FirstName`, `FieldDescrip`, `FieldUse`) VALUES
('All', '_TimeObs_', 'Time of observation', 'TRUE'),
('WeathTemp', 'AirTemp', 'Air temperature (C) at given time or 24-hr mean temperature indicated by time = 00:00', 'TRUE'),
('WeathTemp', 'AirTempMax', 'Maximum air temperature (C) since last data  (usually 24-hour maximum)', 'TRUE'),
('WeathTemp', 'AirTempMin', 'Minimum air temperature (C) since last data entry (usually 24-hour minimum)', 'TRUE'),
('AdminResMethods', 'AnalysisMethod', 'Sampling and analysis method', 'TRUE'),
('AdminResMethods', 'AnalysisProcedure', 'Procedure (may or may not completely describe the procedure, see AddText)', 'TRUE'),
('PondAppAnal', 'AppFeedAsh', 'Fish feed: ash content (% wet weight)', 'TRUE'),
('PondAppAnal', 'AppFeedCa', 'Fish feed: calcium content (as Ca; % dry weight)', 'TRUE'),
('PondAppAnal', 'AppFeedFat', 'Fish feed: crude fat content (ether extract; % wet weight)', 'TRUE'),
('PondAppAnal', 'AppFeedFiber', 'Fish feed: crude fiber content (% wet weight)', 'TRUE'),
('PondAppAnal', 'AppFeedK', 'Fish feed: potassium content (as P; % dry weight)', 'TRUE'),
('PondAppAnal', 'AppFeedMoist', 'Fish feed: moisture content (% wet weight)', 'TRUE'),
('PondAppAnal', 'AppFeedN', 'Fish feed: total nitrogen content (as N; % dry weight)', 'TRUE'),
('PondAppAnal', 'AppFeedNFE', 'Fish feed: nitrogen-free extract content (NFE; equivalent to carbohydrates; % wet weight)', 'TRUE'),
('PondAppAnal', 'AppFeedOrgC', 'Fish feed: organic carbon content (% dry weight)', 'TRUE'),
('PondAppAnal', 'AppFeedP', 'Fish feed: phosphorous content (as P; % dry weight)', 'TRUE'),
('PondAppAnal', 'AppFeedProt', 'Fish feed: crude protein content (= nitrogen x 6.25; % wet weight)', 'TRUE'),
('PondAppAnal', 'AppFertAsh', 'Inorganic/organic fertilizer: ash content (% wet weight)', 'TRUE'),
('PondAppAnal', 'AppFertCa', 'Inorganic/organic fertilizer: calcium content (as Ca; % dry weight)', 'TRUE'),
('PondAppAnal', 'AppFertCOD', 'Inorganic/organic fertilizer: COD content (% dry weight)', 'TRUE'),
('PondAppAnal', 'AppFertEnergy', 'Inorganic/organic fertilizer: energy content (kcal/kg)', 'TRUE'),
('PondAppAnal', 'AppFertForm', 'Inorganic fertilizer: formula (%, N-P-K)', 'TRUE'),
('PondAppAnal', 'AppFertK', 'Inorganic/organic fertilizer: potassium content (as K; % dry weight)', 'TRUE'),
('PondAppAnal', 'AppFertLNV', 'Liming cmpd.: lime neutralizing value (%, relative to CaCO3)', 'TRUE'),
('PondAppAnal', 'AppFertMg', 'Inorganic/organic fertilizer: magnesium content (as Mg; % dry weight)', 'TRUE'),
('PondAppAnal', 'AppFertMix', 'Inorganic/organic fertilizer: compost mix  (%, basis ?)', 'TRUE'),
('PondAppAnal', 'AppFertN', 'Inorganic/organic fertilizer: total nitrogen content (as N; % dry weight)', 'TRUE'),
('PondAppAnal', 'AppFertNa', 'Inorganic/organic fertilizer: sodium content (as Na; % dry weight)', 'TRUE'),
('PondAppAnal', 'AppFertNO3', 'Inorganic/organic fertilizer: nitrate content (as NO3-N; % dry weight)', 'TRUE'),
('PondAppAnal', 'AppFertOrgC', 'Inorganic/organic fertilizer: organic carbon content (% dry weight)', 'TRUE'),
('PondAppAnal', 'AppFertP', 'Inorganic/organic fertilizer: phosphorous content (as P; % dry weight) - not as P2O5 ???', 'TRUE'),
('PondAppAnal', 'AppFertPDM', 'Inorganic/organic fertilizer: percent dry matter (% wet weight)', 'TRUE'),
('PondAppAnal', 'AppFertS', 'Inorganic/organic fertilizer: sulphur content (as S; % dry weight)', 'TRUE'),
('PondAppRate', 'AppQuan', 'Applied quantity, measured amount based on treatment protcol (kg dry wt./ RU)', 'TRUE'),
('PondAppRate', 'AppRate', 'Applied quantity, calculated (kg dry wt./ ha)', 'TRUE'),
('PondAppRate', 'AppRateTime', 'Applied quantity, calculated (kg dry wt./ ha/ week)   --- not used', 'TRUE'),
('All', 'DateObs', 'Date of observation', 'TRUE'),
('All', 'DepthObs', 'Water depth of observation (m; -1 for mixed column)', 'TRUE'),
('FishSamplingSpecial', 'FemLnSamMn', 'Female length (fork) sample mean (cm)', 'TRUE'),
('FishSamplingSpecial', 'FemLnSamNo', 'Female length (fork) sample number (no. fish)', 'TRUE'),
('FishSamplingSpecial', 'FemLnSamSD', 'Female length (fork) sample standard deviation (cm)', 'TRUE'),
('FishSamplingSpecial', 'FemWtSamMn', 'Female weight (wet) sample mean (g)', 'TRUE'),
('FishSamplingSpecial', 'FemWtSamNo', 'Female weight (wet) sample number (no. fish)', 'TRUE'),
('FishSamplingSpecial', 'FemWtSamSD', 'Female weight (wet) sample standard deviation (g)', 'TRUE'),
('DataFields', 'FieldDescrip', 'Field description (definition)', 'TRUE'),
('AdminResMethods', 'FieldName', 'Variable (data field) name used in Database', 'TRUE'),
('DataFields', 'FieldTable', 'Table name where field name found', 'TRUE'),
('DataFields', 'FieldUse', 'Field ready state for show to database users (yes = true)', 'TRUE'),
('All', 'FishCode', 'Fish specie', 'TRUE'),
('FishSampling', 'FishLnSamMn', 'Fish length (fork) sample mean (cm)', 'TRUE'),
('FishSampling', 'FishLnSamNo', 'Fish length (fork) sample number (no. fish)', 'TRUE'),
('FishSampling', 'FishLnSamSD', 'Fish length (fork) sample standard deviation (cm)', 'TRUE'),
('All', 'FishManagCode', 'Fish sample (stock, culture period, or harvest)', 'TRUE'),
('AdminStudies', 'FishMort', 'Number of data entries in database for given project code and data type       *** Fields here and below are filled by query ***', 'TRUE'),
('FishMort', 'FishMortObs', 'Fish-dead/moribund observation (no. fish)', 'TRUE'),
('FishCompAnal', 'FishN', 'Fish: total nitrogen content (as N; % dry weight)', 'TRUE'),
('FishObserv', 'FishObs', 'Fish and/or RU observation and/or task (text)', 'TRUE'),
('FishCompAnal', 'FishOrgC', 'Fish: organic carbon content (% dry weight)', 'TRUE'),
('FishCompAnal', 'FishP', 'Fish: phosphorous content (as P; % dry weight)', 'TRUE'),
('FishCompAnal', 'FishPDM', 'Fish: percent dry matter (% wet weight)', 'TRUE'),
('FishSampling', 'FishPopMnWt', 'Population mean fish weight (calculated, g fish/fish)', 'FALSE'),
('FishSampling', 'FishPopNum', 'Total population, stock/harvest, no reprod. (no. fish)', 'FALSE'),
('FishSampling', 'FishPopTotWt', 'Total pop. weight, stock/harvest, no reprod. (kg fish)', 'FALSE'),
('FishSampling', 'FishRepMnWt', 'Reproduction mean fish weight (calculated, g fish/fish)', 'FALSE'),
('FishSampling', 'FishRepNum', 'Total reproduction (no. fish)', 'FALSE'),
('FishSampling', 'FishRepTotWt', 'Total reproduction weight (kg fish)', 'FALSE'),
('All', 'FishRU', 'Replicate code (pond name)', 'TRUE'),
('AdminStudies', 'FishSampling', 'Number of data entries in database for given project code and data type', 'TRUE'),
('FishSampling', 'FishSurv', 'Fish survival at harvest (calculated, %)', 'TRUE'),
('FishSampling', 'FishWtMean', 'Mean fish weight (wet, g)', 'TRUE'),
('FishSampling', 'FishWtSamMn', 'Fish weight (wet) sample mean  (g)', 'FALSE'),
('FishSampling', 'FishWtSamNo', 'Fish weight (wet) sample number (no. fish)', 'TRUE'),
('FishSampling', 'FishWtSamSD', 'Fish weight (wet) sample standard deviation (g)', 'TRUE'),
('WeathHydro', 'HydroCloud', 'Cloud cover index (most likely units are oktas, 0-8, rather than 0-10 based index system)', 'TRUE'),
('WeathHydro', 'HydroEvap', 'Evaporation (mm/d)', 'TRUE'),
('WeathHydro', 'HydroHumid', 'Relative humidity (%)', 'TRUE'),
('WeathHydro', 'HydroHumidMax', 'Relative humidity (%)', 'TRUE'),
('WeathHydro', 'HydroHumidMin', 'Relative humidity (%)', 'TRUE'),
('WeathHydro', 'HydroRain', 'Rainfall (mm/day; some are cm/day ???)', 'TRUE'),
('WeathHydro', 'HydroRainDur', 'Rainfall, duration (hr; some are min ???)', 'TRUE'),
('FishSamplingSpecial', 'MalLnSamMn', 'Male length (fork) sample mean (cm)', 'TRUE'),
('FishSamplingSpecial', 'MalLnSamNo', 'Male length (fork) sample number (no. fish)', 'TRUE'),
('FishSamplingSpecial', 'MalLnSamSD', 'Male length (fork) sample standard deviation (cm)', 'TRUE'),
('FishSamplingSpecial', 'MalWtSamMn', 'Male weight (wet) sample mean (g)', 'TRUE'),
('FishSamplingSpecial', 'MalWtSamNo', 'Male weight (wet) sample number (no. fish)', 'TRUE'),
('FishSamplingSpecial', 'MalWtSamSD', 'Male weight (wet) sample standard deviation (g)', 'TRUE'),
('CodesManag', 'ManagCode', 'Management code. Use the prefix INITIAL_ with compound application codes to indicate one time, pre-treatment applications.', 'TRUE'),
('CodesManag', 'ManagDescrip', 'Management description', 'TRUE'),
('CodesManag', 'ManagNotes', 'Management code/description notes and further information.', 'TRUE'),
('CodesManag', 'ManagType', 'Type of management code', 'TRUE'),
('AdminResMethods', 'MethodReference', 'Method reference', 'TRUE'),
('ExpTreatFishRU', 'PeriodExp', 'Mean time period of experiment (days), calc. from lowest starting date and highest ending date of fish (and app?) data, used dates in old ExpLIst', 'TRUE'),
('WatQualPlank', 'PlankAlycif', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankAneurae', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankAngular', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankAsplan', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankBG', 'Phytoplankton - blue green (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankBidentat', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankCaudatus', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankCladocer', 'Zooplankton - cladocerans (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankCopepoda', 'Zooplankton - copepods (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankDiaph', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankDiatom', 'Phytoplankton - diatom (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankEncentr', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankFalcatus', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankFilinia', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankGreen', 'Phytoplankton - green (no./L)', 'TRUE'),
('WatQualPlank', 'PlankHavanaen', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankHexarth', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankKerattel', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankLecane', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankMacrothx', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankMoina', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankNauplius', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankNilsoni', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankOphyto', 'Phytoplankton - other (no./L)', 'TRUE'),
('WatQualPlank', 'PlankOstracod', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankOzoo', 'Zooplankton - other (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankPolyarth', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankQuadri', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankRndWrm', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankRotifera', 'Zooplankton - rotifers (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankRotozoa', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankThrmocyc', 'Plankton -  (no./m3)', 'TRUE'),
('CodesPlank', 'PlanktonCode', 'Plankton code', 'TRUE'),
('CodesPlank', 'PlanktonName', 'Plankton name (not completed)', 'TRUE'),
('WatQualPlank', 'PlankTricho', 'Plankton -  (no./m3)', 'TRUE'),
('WatQualPlank', 'PlankTrochos', 'Plankton -  (no./m3)', 'TRUE'),
('AdminStudies', 'PondAppAnal', 'Number of data entries in database for given project code and data type', 'TRUE'),
('AdminStudies', 'PondAppRate', 'Number of data entries in database for given project code and data type', 'TRUE'),
('CodesSite', 'PondArea', 'Pond nominal areas (m2) - based on CRSP pubs.', 'TRUE'),
('CodesSite', 'PondName', 'Pond names for site found in database', 'TRUE'),
('AdminStudies', 'PondSoil', 'Number of data entries in database for given project code and data type', 'TRUE'),
('WatQualPlankNew', 'ProdBenCount', 'Benthic organism count (number/m2)', 'TRUE'),
('WatQualPlankNew', 'ProdBenType', 'Benthic organism group (code)', 'TRUE'),
('WatQualProd', 'ProdBOD2', 'BOD, 2 day (mg O2/L)', 'TRUE'),
('WatQualProd', 'ProdChlaCorr', 'Chlorophyll-a corrected (mg/m3)', 'TRUE'),
('WatQualProd', 'ProdChlaUnCorr', 'Chlorophyll-a uncorrected (mg/m3)', 'TRUE'),
('WatQualProd', 'ProdChlbUnCorr', 'Chlorophyll-b uncorrected (mg/m3)', 'TRUE'),
('WatQualProd', 'ProdChlcUnCorr', 'Chlorophyll-c uncorrected (mg/m3)', 'TRUE'),
('WatQualProd', 'ProdGPPC', 'Gross primary productivity (mg C/L/day = g C/m3/day)', 'TRUE'),
('WatQualProd', 'ProdGPPCX', 'Gross primary productivity (mg C/m3/day, some mg C/L/day ?; original dayabase units, CRSP Handbook ?)', 'TRUE'),
('WatQualProd', 'ProdGPPO2', 'Gross primary productivity (D/L bottle or whole-pond methods; mg O2/L/day = g O2/m3/day)', 'TRUE'),
('WatQualProd', 'ProdGPPO2X', 'Gross primary productivity (D/L bottle or whole-pond methods; mg O2/m3/day, some mg O2/L/day ?; original database units, but not CRSP Handbook)', 'TRUE'),
('WatQualProd', 'ProdNPPC', 'Net primary productivity (mg C/L/day = g C/m3/day)', 'TRUE'),
('WatQualProd', 'ProdNPPCompO2', 'Net primary productivity, compensated, Bart ???, (mg O2/L/day = g O2/m3/day)', 'TRUE'),
('WatQualProd', 'ProdNPPCX', 'Net primary productivity (mg C/m3/d, some mg C/L/d ?; original database units, CRSP Handbook ?)', 'TRUE'),
('WatQualProd', 'ProdNPPO2', 'Net primary productivity (mg O2/L/day = g O2/m3/day)', 'TRUE'),
('WatQualPlankNew', 'ProdPhytoCount', 'Phytoplankton count (number/L)', 'TRUE'),
('WatQualPlankNew', 'ProdPhytoCountX', 'Phytoplankton count (L/L)', 'TRUE'),
('WatQualPlankNew', 'ProdPhytoType', 'Phytoplankton group (code)', 'TRUE'),
('WatQualProd', 'ProdRespO2', 'Community respiration (dark bottle or whole-pond methods; mg O2/L/day = g O2/m3/day)', 'TRUE'),
('WatQualProd', 'ProdRespO2X', 'Community respiration (dark bottle or whole-pond methods; mg O2/m3/day, some mg O2/L/day ?; original database units, CRSP Handbook)', 'TRUE'),
('WatQualProd', 'ProdSecchi', 'Secchi disk visibility depth, calculated mean (cm)', 'TRUE'),
('WatQualProd', 'ProdSecchiA', 'Secchi disk visibility depth, position A or only measurement (cm)', 'TRUE'),
('WatQualProd', 'ProdSecchiB', 'Secchi disk visibility depth, position B (cm)', 'TRUE'),
('WatQualProd', 'ProdSollTotOrgC', 'Total organic carbon (mg C/L)', 'TRUE'),
('WatQualProd', 'ProdSolTotSett', 'Total settleable solids (mg/L)', 'TRUE'),
('WatQualProd', 'ProdSolTotSusp', 'Total suspended solids (mg/L)', 'TRUE'),
('WatQualProd', 'ProdSolTotVol', 'Suspended volatile solids (mg/L)', 'TRUE'),
('WatQualPlankNew', 'ProdZooCount', 'Zooplankton count (number/L)', 'TRUE'),
('WatQualPlankNew', 'ProdZooCountX', 'Zooplankton count (number/m3)', 'TRUE'),
('WatQualPlankNew', 'ProdZooType', 'Zooplankton group (code)', 'TRUE'),
('All', 'ProjectCode', 'Project code', 'TRUE'),
('AdminStudies', 'ProjectDataStat', 'Data submitted and complete (to Database Manager): 0= no, 1= yes, 2= not applicable (none due)', 'TRUE'),
('AdminStudies', 'ProjectDescrip', 'Project objectives, experimental hypothesis. Example: Response of fish productivity to chicken manure fertilization rates', 'TRUE'),
('AdminStudies', 'ProjectEmail', 'Project leader email', 'TRUE'),
('AdminStudies', 'ProjectEndDateText', 'Project (experiment) ending date', 'TRUE'),
('AdminStudies', 'ProjectLeader', 'Project leader', 'TRUE'),
('AdminStudies', 'ProjectPubsCRSP', 'PD/A CRSP Workplan and Technical Report documents', 'TRUE'),
('AdminStudies', 'ProjectPubsNonCRSP', 'Journal papers, proceedings, presentations, etc.', 'TRUE'),
('AdminStudies', 'ProjectSiteCode', 'Site code(s). If more than one site, then primary site.', 'TRUE'),
('AdminStudies', 'ProjectStartDateText', 'Project (experiment) starting date', 'TRUE'),
('AdminStudies', 'ProjectTheme', 'Project theme (for WP 8+)', 'TRUE'),
('AdminStudies', 'ProjectTitle', 'Project title', 'TRUE'),
('AdminStudies', 'ProjectURL', 'Project workplan URL (for WP 8+)', 'TRUE'),
('AdminStudies', 'ProjectWP', 'Workplan number', 'TRUE'),
('Publications', 'PubAbstract', 'Publication abstract (very useful)', 'TRUE'),
('Publications', 'PubAuthors', 'Publication authors and affiliations', 'TRUE'),
('PubTypes', 'PubCanBeParent', 'Publication parent status', 'TRUE'),
('Publications', 'PubDescription', 'Publication description (this field is to be combined to other fields and deleted)', 'TRUE'),
('PubTypes', 'PubExtra', 'Publication extra...', 'TRUE'),
('Publications', 'PubFileSizeHtml', 'File size (KB) for HTML document (enter 0 if not available)', 'TRUE'),
('Publications', 'PubFileSizePdf', 'File size (KB) for PDF document  (enter 0 if not available)', 'TRUE'),
('Publications', 'PubIndex', 'Publication index number for database lookup  (entered automatically)', 'TRUE'),
('Publications', 'PubIsOrderable', 'Can this publication be ordered through the PD/A CRSP ?  TRUE or FALSE', 'TRUE'),
('Publications', 'PubLanguage', 'Publication language: (1) English, (2) French, (3) Spanish', 'TRUE'),
('Publications', 'PubPDACrsp', 'Is this a publication of the PD/A CRSP ? TRUE or FALSE', 'TRUE'),
('Publications', 'PubReference', 'Publication reference (this should be complete enough to use as a formal citation)', 'TRUE'),
('Publications', 'PubSequenceNumber', 'Publication sequence number', 'TRUE'),
('Publications', 'PubSiteCode', 'Publication site code (site codes, separated by commas; see site codes at http://biosys.bre.orst.edu/crspDB/default.htm; enter ''Z'' if publication applies to all sites)', 'TRUE'),
('Publications', 'PubSubmissionDate', 'Date of publication submission (entered automatically)', 'TRUE'),
('Publications', 'PubTitle', 'Publication title', 'TRUE'),
('Publications', 'PubType', 'Publication type: (1) AquaNews, (2), Annual Administrative Reports, (3) Annual Technical Reports, (4) Workplans, (5) Research Reports, (6) Other Technical Publications, (7) Research Publications, (8) General Publications', 'TRUE'),
('PubTypes', 'PubTypeDescription', 'Publication description', 'TRUE'),
('PubTypes', 'PubTypeName', 'Publication type name', 'TRUE'),
('PubTypes', 'PubTypeNumber', 'Publication type number', 'TRUE'),
('Publications', 'PubURLabstract', 'URL for publication abstract (enter NA if not available)', 'TRUE'),
('Publications', 'PubURLhtml', 'URL for HTML document or access to HTML document (enter NA if not available)', 'TRUE'),
('Publications', 'PubURLpdf', 'URL for PDF document (enter NA if not available)', 'TRUE'),
('Publications', 'PubYear', 'Publication year', 'TRUE'),
('AdminResMethods', 'ReferenceUse', 'PD/A CRSP Handbook of Analytical Methods: referenced method is copied and pasted into the ''Procedure'' database field.', 'TRUE'),
('AdminResMethods', 'ReportingUnits', 'Variable reporting units', 'TRUE'),
('AdminResMethods', 'SampleType', 'Sample type - PD/A CRSP Handbook of Analytical Methods', 'TRUE'),
('AdminResMethods', 'SampleVariable', 'Variable measured', 'TRUE'),
('CodesSite', 'SiteCode', 'Site code', 'TRUE'),
('CodesSite', 'SiteCtry', 'Site country', 'TRUE'),
('CodesSite', 'SiteElev', 'Site elevation (m)', 'TRUE'),
('CodesSite', 'SiteLat', 'Site latitude (deg. N/S)', 'TRUE'),
('CodesSite', 'SiteLong', 'Site longitude (deg.)', 'TRUE'),
('CodesSite', 'SiteName', 'Site name, short version', 'TRUE'),
('CodesSite', 'SiteNameFull', 'Site name, long version', 'TRUE'),
('CodesSite', 'SiteUseDates', 'Dates of site use', 'TRUE'),
('PondSoil', 'SoilAl', 'Aluminum (exchangeable acidic cation; mg Al/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilB', 'Boron (mg B/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilBa', 'Barium (mg Ba/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilBaseSat', 'Base saturation (%)', 'TRUE'),
('PondSoil', 'SoilBulkDen', 'Dry bulk density (g dry soil/cm3)', 'TRUE'),
('PondSoil', 'SoilBulkDenX', 'Dry bulk density (kg dry soil/m3)', 'TRUE'),
('PondSoil', 'SoilC', 'Total carbon (mg C/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilCa', 'Calcium (mg Ca/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilCaCO3', 'Free CaCO3 or CaCO3 equivalent (meq/L)', 'TRUE'),
('PondSoil', 'SoilCaEQ', 'Calcium (exchangeable basic cation; meq Ca /100 g dry soil)           *** was SoilCa', 'TRUE'),
('PondSoil', 'SoilCEC', 'Cation exchange capacity (meq/100 g = cmol/kg)', 'TRUE'),
('PondSoil', 'SoilCl', 'Chloride (mg Cl/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilClay', 'Clay (% dry weight)', 'TRUE'),
('PondSoil', 'SoilCo', 'Cobalt (mg Co/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilColor', 'Standard Munsell color chart units', 'TRUE'),
('PondSoil', 'SoilCPC', 'Total carbon (% dry weight soil)', 'TRUE'),
('PondSoil', 'SoilCr', 'Chromium (mg Cr/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilCu', 'Copper (mg Cu/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilDepth', 'Mean depth of soil sample from soil surface (cm; standard core is 5-cm total depth, 2.5-cm mean depth)', 'TRUE'),
('PondSoil', 'SoilFe', 'Iron (exchangeable acidic cation; mg Fe/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilH', 'Exchangeable acidity (exchangeable acidic cation, meq/100 g dry soil)', 'TRUE'),
('PondSoil', 'SoilIncubCO2', 'Carbon dioxide respiration under aerobic conditions (mg CO2/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilIncubNH4', 'Total ammonia consumption (-) or production (+) under anaerobic conditions (mg NH4-N/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilIncubNM', 'Net nitrogen mineralization under aerobic conditions (mg NH4-N/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilK', 'Potassium (exchangeable basic cation; mg K/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilLimeReq', 'Lime requirement (kg CaCO3/ha)', 'TRUE'),
('PondSoil', 'SoilMg', 'Magnesium (mg Mg/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilMgEQ', 'Magnesium (exchangeable basic cation; meq/100 g dry soil)              ***was SoilMg', 'TRUE'),
('PondSoil', 'SoilMn', 'Manganese (mg Mn/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilMo', 'Molybdenum (mg Mo/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilMoist', 'Moisture content (% wet weight)', 'TRUE'),
('PondSoil', 'SoilN', 'Total nitrogen (mg N/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilNa', 'Sodium (mg Na/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilNaEQ', 'Sodium (exchangeable basic cation; meq/100 g dry soil)                   ***was SoilNa', 'TRUE'),
('PondSoil', 'SoilNH4', 'Ammonium nitrogen (mg NH4-N/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilNO3', 'Nitrate nitrogen (mg NO3-N/ kg)', 'TRUE'),
('PondSoil', 'SoilNPC', 'Total nitrogen (% dry weight soil)', 'TRUE'),
('PondSoil', 'SoilOrg', 'Organic matter (% dry weight)', 'TRUE'),
('PondSoil', 'SoilP', 'Total phosphorous (mg P/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilPA', 'Dilute acid extractable phosphorous (mg P/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilPb', 'Lead (mg Pb/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilPh', 'Soil pH (assumed equivalent to wet soil pH)', 'TRUE'),
('PondSoil', 'SoilPhDry', 'Dry soil pH', 'TRUE'),
('PondSoil', 'SoilPhWet', 'Wet soil pH', 'TRUE'),
('PondSoil', 'SoilPO4', 'Total ortho-phosphate (mg PO4-P/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilPPC', 'Total phosphorous (% dry weight soil)', 'TRUE'),
('PondSoil', 'SoilPW', 'Water extractable phosphorous (mg P/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilPY', 'Pyrite (mg/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilS', 'Total sulfur (mg S/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilSalt', 'Soluble salts (mmhos/cm)', 'TRUE'),
('PondSoil', 'SoilSand', 'Sand (% dry weight)', 'TRUE'),
('PondSoil', 'SoilSilt', 'Silt (% dry weight)', 'TRUE'),
('PondSoil', 'SoilSO4', 'Sulfate sulfur (mg SO4-S/ kg dry soil)', 'TRUE'),
('PondSoil', 'SoilSPC', 'Total sulfur (% dry weight soil)', 'TRUE'),
('PondSoil', 'SoilTexture', 'Soil texture (code)', 'TRUE'),
('PondSoil', 'SoilTotAcid', 'Total acidity (units ?)', 'TRUE'),
('PondSoil', 'SoilZn', 'Zinc (mg Zn/ kg dry soil)', 'TRUE'),
('CodesSolar', 'SolarCode', 'Solar radiation unit code', 'TRUE'),
('WeathSolar', 'SolarData1', 'Solar radiation: sunshine min/day, use ?', 'TRUE'),
('WeathSolar', 'SolarData2', 'Sunshine period (min/d), use  ?', 'TRUE'),
('WeathSolar', 'SolarData3', 'Sunshine period (min/d), use  ?', 'TRUE'),
('WeathSolar', 'SolarDuration', 'Solar radiation duration (hr) (period of bright sunshine)', 'TRUE'),
('CodesSolar', 'SolarName', 'Solar radiation unit field name (old, internal)', 'TRUE'),
('CodesSolar', 'SolarNotes', 'Notes (old, internal)', 'TRUE'),
('WeathSolar', 'SolarRadC', 'Solar radiation (C units: cal/cm2/day), range 0-1000', 'TRUE'),
('WeathSolar', 'SolarRadCum', 'Cumulative solar radiation (units/day; units defined by associated solar radiation value)', 'TRUE'),
('WeathSolar', 'SolarRadE', 'Solar radiation (E units:  E/m2/day), measured by quantum sensor versus pyranometer', 'TRUE'),
('WeathSolar', 'SolarRadK', 'Solar radiation (K units: kWhr/m2/day), range 0-1', 'TRUE'),
('WeathSolar', 'SolarRadL', 'Solar radiation (L units/d: lux/m2/day), range 10000 - 150000', 'TRUE'),
('WeathSolar', 'SolarRadM', 'Solar radiation (M units: MJ/m2/day), range 0 - 30', 'TRUE'),
('CodesSolar', 'SolarUnit', 'Solar radiation unit definition', 'TRUE'),
('ExpTreatTable', 'Table', 'Table name - tables confirmed to have all exp/pond/cage primary keys represented in ExpTreat', 'FALSE'),
('DataBaseTables', 'TableDescription', 'User-form label for the table', 'TRUE'),
('DataBaseTables', 'TableLevel', 'Basis of table organization: Global (G), Site (S), Experiment (E), Treatment (T), Replicate (R)', 'TRUE'),
('DataBaseTables', 'TableName', 'Database table name', 'TRUE'),
('DataBaseTables', 'TableUse', 'User = general user use.  Blank = in-house use only or not currently ready for Web Site.', 'TRUE'),
('DataBaseTables', 'TableUserQuery', 'Indicates this table is used in generating user queries', 'TRUE'),
('All', 'TreatCode', 'Treatment code (experiment treatment)', 'TRUE'),
('WatQualPhAlk', 'WatAlk', 'Total alkalinity (mg CaCO3/L)', 'TRUE'),
('WatQuan', 'WatArea', 'Water surface area (m2)', 'TRUE'),
('ExpTreatFishRU', 'WatAreaSpec', 'Water surface area of pond (m2; exp./treat. specification)', 'TRUE'),
('WatQuanSpec', 'WatAreaTest', 'Water surface area (m2), at test depth of 0.0 to 1.0+ meters', 'TRUE'),
('WatQualMinor', 'WatB', 'Boron (mg/L)', 'TRUE'),
('WatQualMinor', 'WatCa', 'Calcium (mg/L)', 'TRUE'),
('WatQualSal', 'WatCl', 'Chlorinity (mg/L)', 'TRUE'),
('WatQualMinor', 'WatCO2', 'Carbon dioxide (mg CO2/L)  Note: would be better placed with pH and alkalinity, but rarely reported.', 'TRUE'),
('WatQualSal', 'WatCond', 'Conductivity (mhos)', 'TRUE'),
('WatQualMinor', 'WatCu', 'Copper (mg/L)', 'TRUE'),
('WatQuan', 'WatDepth', 'Water depth (m)', 'TRUE'),
('ExpTreatFishRU', 'WatDepthSpec', 'Water depth of pond (m; exp./treat. specification)', 'TRUE'),
('WatQuanSpec', 'WatDepthTest', 'Water depth (m),  test depth of 0.0 to 1.0+ meters', 'TRUE'),
('WatQualNP', 'WatDIN', 'Total dissolved nitrogen (calculated, mg N/L)', 'TRUE'),
('WatQualNP', 'WatDIP', 'Total dissolved inorganic phosphorous, or soluble reactive phosphorous (SRP), ortho-P form,  (PO4) (mg P/L)  Note: some values may be total diss. P ???', 'TRUE'),
('WatQualDO', 'WatDO', 'Dissolved oxygen (mg O2/L)', 'TRUE'),
('WatQualMinor', 'WatFe', 'Iron  (mg/L)', 'TRUE'),
('WatQuan', 'WatFlowEff', 'Water overflow via effluent structure (Y/N)', 'TRUE'),
('WatQuan', 'WatFlowEffEventCM', 'Water discharged during exchange event (cm)', 'TRUE'),
('WatQuan', 'WatFlowEffEventM3', 'Water discharged during exchange event (m3)', 'TRUE'),
('WatQuan', 'WatFlowEffRate', 'Water effluent flowrate (m3/d)', 'TRUE'),
('WatQuan', 'WatFlowInf', 'Water inflow via influent structure (Y/N)', 'TRUE'),
('WatQuan', 'WatFlowInfEventCM', 'Water added during exchange or makeup event (cm)', 'TRUE'),
('WatQuan', 'WatFlowInfEventM3', 'Water added during exchange or makeup event (m3)', 'TRUE'),
('WatQuan', 'WatFlowInfRate', 'Water influent flowrate (m3/d)', 'TRUE'),
('WatQuan', 'WatFlowSeep', 'Water seepage (+/- net, cm/d)', 'TRUE'),
('WatQuan', 'WatFlowSeepEvap', 'Water seepage and evaporation (combined; +/- net, cm/d)', 'TRUE'),
('WatQualMinor', 'WatHard', 'Water hardness (mg CaCO3/L)', 'TRUE'),
('WatQualMinor', 'WatK', 'Potassium (mg/L)', 'TRUE'),
('WatQualMinor', 'WatMg', 'Magnesium (mg/L)', 'TRUE'),
('WatQualMinor', 'WatNa', 'Sodium (mg/L)', 'TRUE'),
('WatQualNP', 'WatNO23N', 'Nitrate and nitrite nitrogen (mg N/ L)', 'TRUE'),
('WatQualNP', 'WatNO2N', 'Nitrite nitrogen (mg NO2-N/ L)', 'TRUE'),
('WatQualNP', 'WatNO3N', 'Nitrate nitrogen (mg NO3-N/ L)', 'TRUE'),
('WatQuanSpec', 'WatNomArea', 'Pond area value used for nominal 1.0 m depth (Y/N),  internal use only', 'TRUE'),
('WatQualPhAlk', 'WatPH', 'pH (NBS scale)', 'TRUE'),
('WatQuanSpec', 'WatPondMap', 'Link to fish rearing-unit map (plane table or simple survey)', 'TRUE'),
('AdminStudies', 'WatQualDO', 'Number of data entries in database for given project code and data type', 'TRUE'),
('AdminStudies', 'WatQualMinor', 'Number of data entries in database for given project code and data type', 'TRUE'),
('AdminStudies', 'WatQualNP', 'Number of data entries in database for given project code and data type', 'TRUE'),
('AdminStudies', 'WatQualPhAlk', 'Number of data entries in database for given project code and data type', 'TRUE'),
('AdminStudies', 'WatQualPlank', 'Number of data entries in database for given project code and data type', 'TRUE'),
('AdminStudies', 'WatQualProd', 'Number of data entries in database for given project code and data type', 'TRUE'),
('AdminStudies', 'WatQualSal', 'Number of data entries in database for given project code and data type', 'TRUE'),
('AdminStudies', 'WatQualTAN', 'Number of data entries in database for given project code and data type', 'TRUE'),
('AdminStudies', 'WatQualTemp', 'Number of data entries in database for given project code and data type', 'TRUE'),
('AdminStudies', 'WatQualTempMM', 'Number of data entries in database for given project code and data type', 'TRUE'),
('AdminStudies', 'WatQuan', 'Number of data entries in database for given project code and data type', 'TRUE'),
('AdminStudies', 'WatQuanSpec', 'Number of data entries in database for given project code and data type', 'TRUE'),
('WatQualSal', 'WatSal', 'Salinity (ppt)', 'TRUE'),
('WatQualMinor', 'WatSO4', 'Sulfate (mg/L)', 'TRUE'),
('WatQualTAN', 'WatTAN', 'Total ammonia nitrogen (mg NH3-N + NH4-N/ L  =  mg TAN/L)', 'TRUE'),
('WatQualTemp', 'WatTemp', 'Water temperature (C), at given time', 'TRUE'),
('WatQualTempMM', 'WatTempMax', 'Maximum water temperature (C), since last data', 'TRUE'),
('WatQualTempMM', 'WatTempMin', 'Minimum water temperature (C), since last data', 'TRUE'),
('WatQualNP', 'WatTotN', 'Total dissolved and undissolved nitrogen (Kjeldahl nitrogen) (mg N/L)', 'TRUE'),
('WatQualNP', 'WatTotP', 'Total dissolved and undissolved phosphorous (mg P/L)', 'TRUE'),
('WatQuan', 'WatVol', 'Water volume (m3)', 'TRUE'),
('ExpTreatFishRU', 'WatVolSpec', 'Water volume of pond (m2; exp./treat. specification)', 'TRUE'),
('WatQuanSpec', 'WatVolTest', 'Water volume (m3),  at test depth of 0.0 to 1.0+ meters', 'TRUE'),
('WatQualMinor', 'WatZn', 'Zinc  (mg/L)', 'TRUE'),
('AdminStudies', 'WeathHydro', 'Number of data entries in database for given project code and data type', 'TRUE'),
('AdminStudies', 'WeathSolar', 'Number of data entries in database for given project code and data type', 'TRUE'),
('AdminStudies', 'WeathTemp', 'Number of data entries in database for given project code and data type', 'TRUE'),
('AdminStudies', 'WeathWind', 'Number of data entries in database for given project code and data type', 'TRUE'),
('WeathWind', 'WindDir', 'Wind direction code (NSEW compass based; see codes table)', 'TRUE'),
('CodesWind', 'WindDirec', 'Wind direction (NSEW)', 'TRUE'),
('CodesWind', 'WindDirecCode', 'Wind direction (code)', 'TRUE'),
('WeathWind', 'WindDirNum', 'Wind direction code (numerically based; see codes table)', 'TRUE'),
('CodesWind', 'WindHiAzim', 'Wind high azimuth (degrees)', 'TRUE'),
('CodesWind', 'WindLoAzim', 'Wind low azimuth (degrees)', 'TRUE'),
('WeathWind', 'WindSpd', 'Mean wind speed of period (km/hr)', 'TRUE'),
('WeathWind', 'WindSpdCum', 'Cumulative wind distance (km)', 'TRUE'),
('WeathWind', 'WindSpdPer', 'Time period of observation  (days)', 'TRUE');
